// See the DataAccess setup code on the DataAccess class page.

// Executes a Select statement and retrieves the DataTable object.
private static void GetProcedureDataTable(DataAccess dataAccess)
{
    // Add(string parameterName, SqlDbType sqlDbType, int size
    //   , object value = null, ParameterDirection direction = ParameterDirection.Input)
    var parameters = new ProcedureParameters()
    {
        { "@ID", SqlDbType.Int, 0, 8 }
    };

    string procedureName = "dbo.sp_RetrieveByID";

    var dataTable = dataAccess.GetProcedureDataTable(procedureName
        , parameters);
    if (dataTable != null)
    {
        foreach (DataRow dataRow in dataTable.Rows)
        {
            for int index = 0; index < dataTable.Columns.Count; index++)
            {
                string value = dataRow[index].ToString();
            }
        }
    }
}